﻿CREATE TABLE [dbo].[PurchaseDetail] (
    [PurchaseNo]    VARCHAR (30)    NOT NULL,
    [LineNo]        VARCHAR (3)     NOT NULL,
    [ProductNo]     VARCHAR (10)    NOT NULL,
    [LotNo]         VARCHAR (20)    NULL,
    [ProductDate]   DATETIME        NULL,
    [Qty]           NUMERIC (10, 2) NULL,
    [Price]         NUMERIC (10, 2) NULL,
    [Amount]        NUMERIC (15, 2) NULL,
    [DiscountRate]  NUMERIC (10, 4) NULL,
    [DiscountPrice] NUMERIC (10, 2) NULL,
    [DiscountAmt]   NUMERIC (15, 2) NULL,
    [TaxRate]       NUMERIC (10, 4) NULL,
    [TaxAmount]     NUMERIC (15, 2) NULL,
    [PriceInTax]    NUMERIC (10, 2) NULL,
    [AmountInTax]   NUMERIC (15, 2) NULL,
    [ValidDate]     DATETIME        NULL,
    [Remark]        VARCHAR (60)    NULL,
    [RecordID]      INT             IDENTITY (1, 1) NOT NULL
);

